Overview
Dataset statistics
| Number of variables | 11 |
|---|---|
| Number of observations | 10000000 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 839.2 MiB |
| Average record size in memory | 88.0 B |
Variable types
| Numeric | 10 |
|---|---|
| Categorical | 1 |
date_index is highly overall correlated with tr_id | High correlation |
probe_efficiency is highly overall correlated with rtt_count and 2 other fields | High correlation |
rtt_count is highly overall correlated with probe_efficiency and 2 other fields | High correlation |
rtt_range is highly overall correlated with probe_efficiency and 2 other fields | High correlation |
rtt_std is highly overall correlated with probe_efficiency and 2 other fields | High correlation |
tr_id is highly overall correlated with date_index | High correlation |
route_changed is highly imbalanced (85.5%) | Imbalance |
rtt_std is highly skewed (γ1 = 20.26983061) | Skewed |
time_since_last is highly skewed (γ1 = 244.4256114) | Skewed |
tr_id is uniformly distributed | Uniform |
tr_id has unique values | Unique |
rtt_std has 9297044 (93.0%) zeros | Zeros |
rtt_range has 9296183 (93.0%) zeros | Zeros |
time_since_last has 9642814 (96.4%) zeros | Zeros |
Reproduction
| Analysis started | 2025-11-25 21:29:23.804447 |
|---|---|
| Analysis finished | 2025-11-25 21:34:22.215420 |
| Duration | 4 minutes and 58.41 seconds |
| Software version | ydata-profiling vv4.18.0 |
| Download configuration | config.json |
Variables
tr_id
Real number (ℝ)
High correlation Uniform Unique
| Distinct | 10000000 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4999999.5 |
| Minimum | 0 |
|---|---|
| Maximum | 9999999 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 76.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 499999.95 |
| Q1 | 2499999.8 |
| median | 4999999.5 |
| Q3 | 7499999.2 |
| 95-th percentile | 9499999 |
| Maximum | 9999999 |
| Range | 9999999 |
| Interquartile range (IQR) | 4999999.5 |
Descriptive statistics
| Standard deviation | 2886751.5 |
|---|---|
| Coefficient of variation (CV) | 0.57735036 |
| Kurtosis | -1.2 |
| Mean | 4999999.5 |
| Median Absolute Deviation (MAD) | 2500000 |
| Skewness | 4.9533963 × 10-17 |
| Sum | 4.9999995 × 1013 |
| Variance | 8.3333342 × 1012 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3262756 | 1 | < 0.1% |
| 3262755 | 1 | < 0.1% |
| 3262754 | 1 | < 0.1% |
| 3262753 | 1 | < 0.1% |
| 3262752 | 1 | < 0.1% |
| 3262751 | 1 | < 0.1% |
| 3262750 | 1 | < 0.1% |
| 3262749 | 1 | < 0.1% |
| 3262748 | 1 | < 0.1% |
| 3262747 | 1 | < 0.1% |
| Other values (9999990) | 9999990 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 |
| Value | Count | Frequency (%) |
| 9999999 | 1 | |
| 9999998 | 1 | |
| 9999997 | 1 | |
| 9999996 | 1 | |
| 9999995 | 1 | |
| 9999994 | 1 | |
| 9999993 | 1 | |
| 9999992 | 1 | |
| 9999991 | 1 | |
| 9999990 | 1 |
route_changed
Categorical
Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 476.8 MiB |
| 0 | |
|---|---|
| 1 | 205935 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 9794065 | |
| 1 | 205935 | 2.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 9794065 | |
| 1 | 205935 | 2.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 9794065 | |
| 1 | 205935 | 2.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 10000000 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 9794065 | |
| 1 | 205935 | 2.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 10000000 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 9794065 | |
| 1 | 205935 | 2.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 10000000 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 9794065 | |
| 1 | 205935 | 2.1% |
date_index
Real number (ℝ)
High correlation
| Distinct | 42 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 38.32461 |
| Minimum | 1 |
|---|---|
| Maximum | 66 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 76.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 25 |
| median | 43 |
| Q3 | 52 |
| 95-th percentile | 64 |
| Maximum | 66 |
| Range | 65 |
| Interquartile range (IQR) | 27 |
Descriptive statistics
| Standard deviation | 20.079361 |
|---|---|
| Coefficient of variation (CV) | 0.52392866 |
| Kurtosis | -0.79871737 |
| Mean | 38.32461 |
| Median Absolute Deviation (MAD) | 13 |
| Skewness | -0.62542635 |
| Sum | 3.832461 × 108 |
| Variance | 403.18076 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3 | 358706 | 3.6% |
| 4 | 356342 | 3.6% |
| 2 | 352341 | 3.5% |
| 1 | 344452 | 3.4% |
| 24 | 337864 | 3.4% |
| 10 | 317628 | 3.2% |
| 25 | 314066 | 3.1% |
| 49 | 283426 | 2.8% |
| 31 | 279400 | 2.8% |
| 50 | 277772 | 2.8% |
| Other values (32) | 6778003 |
| Value | Count | Frequency (%) |
| 1 | 344452 | |
| 2 | 352341 | |
| 3 | 358706 | |
| 4 | 356342 | |
| 5 | 184526 | |
| 10 | 317628 | |
| 11 | 86005 | 0.9% |
| 23 | 62004 | 0.6% |
| 24 | 337864 | |
| 25 | 314066 |
| Value | Count | Frequency (%) |
| 66 | 177014 | |
| 65 | 220131 | |
| 64 | 221020 | |
| 63 | 221093 | |
| 62 | 233373 | |
| 61 | 230163 | |
| 60 | 231457 | |
| 59 | 229184 | |
| 58 | 235629 | |
| 57 | 235287 |
rtt_mean
Real number (ℝ)
| Distinct | 36730 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 124.56296 |
| Minimum | 0.14 |
|---|---|
| Maximum | 4905.92 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 76.3 MiB |
Quantile statistics
| Minimum | 0.14 |
|---|---|
| 5-th percentile | 36.27 |
| Q1 | 63.22 |
| median | 113.3 |
| Q3 | 137.16 |
| 95-th percentile | 253.4 |
| Maximum | 4905.92 |
| Range | 4905.78 |
| Interquartile range (IQR) | 73.94 |
Descriptive statistics
| Standard deviation | 78.099715 |
|---|---|
| Coefficient of variation (CV) | 0.62698986 |
| Kurtosis | 69.426593 |
| Mean | 124.56296 |
| Median Absolute Deviation (MAD) | 48.85 |
| Skewness | 2.8911233 |
| Sum | 1.2456296 × 109 |
| Variance | 6099.5655 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 45.36 | 42669 | 0.4% |
| 45.34 | 34311 | 0.3% |
| 45.37 | 34143 | 0.3% |
| 45.38 | 33179 | 0.3% |
| 45.35 | 32164 | 0.3% |
| 63.18 | 29353 | 0.3% |
| 92.62 | 28800 | 0.3% |
| 63.2 | 28230 | 0.3% |
| 92.64 | 27778 | 0.3% |
| 63.16 | 27342 | 0.3% |
| Other values (36720) | 9682031 |
| Value | Count | Frequency (%) |
| 0.14 | 99 | |
| 0.15 | 33 | < 0.1% |
| 0.16 | 33 | < 0.1% |
| 0.17 | 33 | < 0.1% |
| 0.18 | 132 | |
| 0.19 | 33 | < 0.1% |
| 0.2 | 33 | < 0.1% |
| 0.21 | 99 | |
| 0.22 | 132 | |
| 0.24 | 198 |
| Value | Count | Frequency (%) |
| 4905.92 | 18 | |
| 4293.06 | 20 | |
| 3756.42 | 21 | |
| 3076.66 | 14 | |
| 2872.35 | 20 | |
| 2804.74 | 19 | |
| 2412.38 | 18 | |
| 1963.63 | 21 | |
| 1771.71 | 33 | |
| 1449.98 | 10 | < 0.1% |
rtt_std
Real number (ℝ)
High correlation Skewed Zeros
| Distinct | 8047 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.1806685 |
| Minimum | 0 |
|---|---|
| Maximum | 1352.71 |
| Zeros | 9297044 |
| Zeros (%) | 93.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 76.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0.92 |
| Maximum | 1352.71 |
| Range | 1352.71 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 16.753856 |
|---|---|
| Coefficient of variation (CV) | 7.6828989 |
| Kurtosis | 618.31546 |
| Mean | 2.1806685 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 20.269831 |
| Sum | 21806685 |
| Variance | 280.69169 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 9297044 | |
| 0.07 | 10274 | 0.1% |
| 0.1 | 9894 | 0.1% |
| 0.08 | 9821 | 0.1% |
| 0.06 | 9808 | 0.1% |
| 0.05 | 9566 | 0.1% |
| 0.09 | 9459 | 0.1% |
| 0.11 | 8718 | 0.1% |
| 0.04 | 8010 | 0.1% |
| 0.12 | 7345 | 0.1% |
| Other values (8037) | 620061 | 6.2% |
| Value | Count | Frequency (%) |
| 0 | 9297044 | |
| 0.01 | 3661 | < 0.1% |
| 0.02 | 5980 | 0.1% |
| 0.03 | 7181 | 0.1% |
| 0.04 | 8010 | 0.1% |
| 0.05 | 9566 | 0.1% |
| 0.06 | 9808 | 0.1% |
| 0.07 | 10274 | 0.1% |
| 0.08 | 9821 | 0.1% |
| 0.09 | 9459 | 0.1% |
| Value | Count | Frequency (%) |
| 1352.71 | 17 | |
| 1107.91 | 18 | |
| 918.03 | 20 | |
| 642.91 | 10 | |
| 633.03 | 8 | < 0.1% |
| 623.69 | 12 | |
| 622.11 | 10 | |
| 619.87 | 9 | |
| 619.74 | 10 | |
| 613.61 | 9 |
rtt_range
Real number (ℝ)
High correlation Zeros
| Distinct | 10611 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.5439869 |
| Minimum | 0 |
|---|---|
| Maximum | 3630.08 |
| Zeros | 9296183 |
| Zeros (%) | 93.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 76.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 2.46 |
| Maximum | 3630.08 |
| Range | 3630.08 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 38.678707 |
|---|---|
| Coefficient of variation (CV) | 6.9766953 |
| Kurtosis | 591.75809 |
| Mean | 5.5439869 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 18.011129 |
| Sum | 55439869 |
| Variance | 1496.0424 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 9296183 | |
| 0.16 | 3970 | < 0.1% |
| 0.15 | 3772 | < 0.1% |
| 0.24 | 3703 | < 0.1% |
| 0.12 | 3677 | < 0.1% |
| 0.11 | 3623 | < 0.1% |
| 0.23 | 3587 | < 0.1% |
| 0.22 | 3577 | < 0.1% |
| 0.19 | 3504 | < 0.1% |
| 0.14 | 3483 | < 0.1% |
| Other values (10601) | 670921 | 6.7% |
| Value | Count | Frequency (%) |
| 0 | 9296183 | |
| 0.01 | 1611 | < 0.1% |
| 0.02 | 1793 | < 0.1% |
| 0.03 | 2067 | < 0.1% |
| 0.04 | 2254 | < 0.1% |
| 0.05 | 2994 | < 0.1% |
| 0.06 | 2860 | < 0.1% |
| 0.07 | 2325 | < 0.1% |
| 0.08 | 3235 | < 0.1% |
| 0.09 | 2525 | < 0.1% |
| Value | Count | Frequency (%) |
| 3630.08 | 17 | |
| 3012.47 | 18 | |
| 2383.93 | 33 | |
| 1836.06 | 20 | |
| 1451.39 | 10 | < 0.1% |
| 1285.83 | 10 | < 0.1% |
| 1272.79 | 10 | < 0.1% |
| 1266.15 | 9 | < 0.1% |
| 1266.06 | 8 | < 0.1% |
| 1249.12 | 9 | < 0.1% |
rtt_count
Real number (ℝ)
High correlation
| Distinct | 73 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.5494145 |
| Minimum | 1 |
|---|---|
| Maximum | 77 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 76.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 5 |
| Maximum | 77 |
| Range | 76 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 2.950475 |
|---|---|
| Coefficient of variation (CV) | 1.9042515 |
| Kurtosis | 151.26332 |
| Mean | 1.5494145 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 10.488764 |
| Sum | 15494145 |
| Variance | 8.7053025 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 9295245 | |
| 7 | 99742 | 1.0% |
| 6 | 96547 | 1.0% |
| 5 | 63626 | 0.6% |
| 4 | 57614 | 0.6% |
| 2 | 56867 | 0.6% |
| 3 | 52886 | 0.5% |
| 12 | 43015 | 0.4% |
| 8 | 35282 | 0.4% |
| 11 | 32629 | 0.3% |
| Other values (63) | 166547 | 1.7% |
| Value | Count | Frequency (%) |
| 1 | 9295245 | |
| 2 | 56867 | 0.6% |
| 3 | 52886 | 0.5% |
| 4 | 57614 | 0.6% |
| 5 | 63626 | 0.6% |
| 6 | 96547 | 1.0% |
| 7 | 99742 | 1.0% |
| 8 | 35282 | 0.4% |
| 9 | 31626 | 0.3% |
| 10 | 31834 | 0.3% |
| Value | Count | Frequency (%) |
| 77 | 6 | < 0.1% |
| 76 | 15 | < 0.1% |
| 75 | 19 | < 0.1% |
| 72 | 15 | < 0.1% |
| 69 | 6 | < 0.1% |
| 68 | 36 | < 0.1% |
| 67 | 14 | < 0.1% |
| 66 | 39 | |
| 65 | 28 | < 0.1% |
| 64 | 90 |
time_since_last
Real number (ℝ)
Skewed Zeros
| Distinct | 1858 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 57.378246 |
| Minimum | 0 |
|---|---|
| Maximum | 3802147 |
| Zeros | 9642814 |
| Zeros (%) | 96.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 76.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 3802147 |
| Range | 3802147 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 5329.5091 |
|---|---|
| Coefficient of variation (CV) | 92.883792 |
| Kurtosis | 89667.465 |
| Mean | 57.378246 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 244.42561 |
| Sum | 5.7378246 × 108 |
| Variance | 28403667 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 9642814 | |
| 660 | 261611 | 2.6% |
| 659 | 3973 | < 0.1% |
| 661 | 3887 | < 0.1% |
| 1320 | 1907 | < 0.1% |
| 693 | 1701 | < 0.1% |
| 668 | 1678 | < 0.1% |
| 676 | 1658 | < 0.1% |
| 652 | 1494 | < 0.1% |
| 694 | 1395 | < 0.1% |
| Other values (1848) | 77882 | 0.8% |
| Value | Count | Frequency (%) |
| 0 | 9642814 | |
| 191 | 1 | < 0.1% |
| 194 | 1 | < 0.1% |
| 258 | 1 | < 0.1% |
| 267 | 1 | < 0.1% |
| 276 | 1 | < 0.1% |
| 294 | 1 | < 0.1% |
| 314 | 1 | < 0.1% |
| 346 | 1 | < 0.1% |
| 360 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 3802147 | 1 | |
| 3802125 | 1 | |
| 1923358 | 1 | |
| 1891447 | 1 | |
| 1846200 | 1 | |
| 1823220 | 1 | |
| 1768269 | 1 | |
| 1724139 | 1 | |
| 1711136 | 1 | |
| 1691880 | 1 |
reply_ratio
Real number (ℝ)
| Distinct | 141 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.99196163 |
| Minimum | 0.33 |
|---|---|
| Maximum | 2.29 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 76.3 MiB |
Quantile statistics
| Minimum | 0.33 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 2.29 |
| Range | 1.96 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.090623265 |
|---|---|
| Coefficient of variation (CV) | 0.091357632 |
| Kurtosis | 43.570788 |
| Mean | 0.99196163 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -2.2232494 |
| Sum | 9919616.3 |
| Variance | 0.0082125762 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 9731264 | |
| 0.5 | 148414 | 1.5% |
| 0.33 | 51768 | 0.5% |
| 1.71 | 12830 | 0.1% |
| 0.88 | 6395 | 0.1% |
| 1.5 | 3837 | < 0.1% |
| 1.57 | 2969 | < 0.1% |
| 0.67 | 2181 | < 0.1% |
| 0.78 | 2061 | < 0.1% |
| 1.83 | 1589 | < 0.1% |
| Other values (131) | 36692 | 0.4% |
| Value | Count | Frequency (%) |
| 0.33 | 51768 | 0.5% |
| 0.46 | 90 | < 0.1% |
| 0.5 | 148414 | |
| 0.55 | 363 | < 0.1% |
| 0.56 | 11 | < 0.1% |
| 0.57 | 29 | < 0.1% |
| 0.6 | 513 | < 0.1% |
| 0.64 | 27 | < 0.1% |
| 0.67 | 2181 | < 0.1% |
| 0.71 | 112 | < 0.1% |
| Value | Count | Frequency (%) |
| 2.29 | 17 | < 0.1% |
| 2.26 | 6 | < 0.1% |
| 2.2 | 34 | < 0.1% |
| 2.17 | 46 | < 0.1% |
| 2.16 | 80 | |
| 2.15 | 5 | < 0.1% |
| 2.14 | 13 | < 0.1% |
| 2.12 | 144 | |
| 2.11 | 48 | < 0.1% |
| 2.1 | 22 | < 0.1% |
probe_efficiency
Real number (ℝ)
High correlation
| Distinct | 73 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.51336885 |
| Minimum | 0.33 |
|---|---|
| Maximum | 25.67 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 76.3 MiB |
Quantile statistics
| Minimum | 0.33 |
|---|---|
| 5-th percentile | 0.33 |
| Q1 | 0.33 |
| median | 0.33 |
| Q3 | 0.33 |
| 95-th percentile | 1.67 |
| Maximum | 25.67 |
| Range | 25.34 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.98403603 |
|---|---|
| Coefficient of variation (CV) | 1.9168207 |
| Kurtosis | 151.05589 |
| Mean | 0.51336885 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 10.48036 |
| Sum | 5133688.5 |
| Variance | 0.9683269 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.33 | 9295245 | |
| 2.33 | 99742 | 1.0% |
| 2 | 96547 | 1.0% |
| 1.67 | 63626 | 0.6% |
| 1.33 | 57614 | 0.6% |
| 0.67 | 56867 | 0.6% |
| 1 | 52886 | 0.5% |
| 4 | 43015 | 0.4% |
| 2.67 | 35282 | 0.4% |
| 3.67 | 32629 | 0.3% |
| Other values (63) | 166547 | 1.7% |
| Value | Count | Frequency (%) |
| 0.33 | 9295245 | |
| 0.67 | 56867 | 0.6% |
| 1 | 52886 | 0.5% |
| 1.33 | 57614 | 0.6% |
| 1.67 | 63626 | 0.6% |
| 2 | 96547 | 1.0% |
| 2.33 | 99742 | 1.0% |
| 2.67 | 35282 | 0.4% |
| 3 | 31626 | 0.3% |
| 3.33 | 31834 | 0.3% |
| Value | Count | Frequency (%) |
| 25.67 | 6 | < 0.1% |
| 25.33 | 15 | < 0.1% |
| 25 | 19 | < 0.1% |
| 24 | 15 | < 0.1% |
| 23 | 6 | < 0.1% |
| 22.67 | 36 | < 0.1% |
| 22.33 | 14 | < 0.1% |
| 22 | 39 | |
| 21.67 | 28 | < 0.1% |
| 21.33 | 90 |
pair_id
Real number (ℝ)
| Distinct | 109 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54.060716 |
| Minimum | 0 |
|---|---|
| Maximum | 124 |
| Zeros | 26937 |
| Zeros (%) | 0.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 76.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 14 |
| Q1 | 32 |
| median | 54 |
| Q3 | 78 |
| 95-th percentile | 92 |
| Maximum | 124 |
| Range | 124 |
| Interquartile range (IQR) | 46 |
Descriptive statistics
| Standard deviation | 27.251264 |
|---|---|
| Coefficient of variation (CV) | 0.50408625 |
| Kurtosis | -1.0957706 |
| Mean | 54.060716 |
| Median Absolute Deviation (MAD) | 24 |
| Skewness | -0.011629467 |
| Sum | 5.4060716 × 108 |
| Variance | 742.63137 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 82 | 229366 | 2.3% |
| 70 | 224932 | 2.2% |
| 54 | 215599 | 2.2% |
| 25 | 212538 | 2.1% |
| 84 | 205739 | 2.1% |
| 30 | 201341 | 2.0% |
| 19 | 189987 | 1.9% |
| 73 | 189514 | 1.9% |
| 16 | 184656 | 1.8% |
| 33 | 178176 | 1.8% |
| Other values (99) | 7968152 |
| Value | Count | Frequency (%) |
| 0 | 26937 | 0.3% |
| 2 | 157491 | |
| 4 | 172050 | |
| 7 | 6546 | 0.1% |
| 8 | 22685 | 0.2% |
| 9 | 23028 | 0.2% |
| 10 | 6547 | 0.1% |
| 11 | 24341 | 0.2% |
| 12 | 42046 | 0.4% |
| 13 | 16515 | 0.2% |
| Value | Count | Frequency (%) |
| 124 | 28 | < 0.1% |
| 123 | 62 | < 0.1% |
| 121 | 4145 | < 0.1% |
| 120 | 114 | < 0.1% |
| 119 | 60 | < 0.1% |
| 118 | 5077 | 0.1% |
| 116 | 127 | < 0.1% |
| 115 | 302 | < 0.1% |
| 114 | 32361 | |
| 113 | 8844 | 0.1% |
Interactions
Correlations
| date_index | pair_id | probe_efficiency | reply_ratio | route_changed | rtt_count | rtt_mean | rtt_range | rtt_std | time_since_last | tr_id | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| date_index | 1.000 | 0.031 | -0.058 | 0.049 | 0.022 | -0.058 | -0.059 | -0.057 | -0.057 | -0.020 | 0.924 |
| pair_id | 0.031 | 1.000 | 0.041 | -0.085 | 0.029 | 0.041 | -0.029 | 0.042 | 0.043 | -0.006 | 0.027 |
| probe_efficiency | -0.058 | 0.041 | 1.000 | 0.112 | 0.021 | 1.000 | -0.170 | 0.998 | 0.998 | 0.017 | -0.055 |
| reply_ratio | 0.049 | -0.085 | 0.112 | 1.000 | 0.025 | 0.112 | -0.092 | 0.108 | 0.106 | -0.012 | 0.042 |
| route_changed | 0.022 | 0.029 | 0.021 | 0.025 | 1.000 | 0.021 | 0.012 | 0.010 | 0.010 | 0.038 | 0.021 |
| rtt_count | -0.058 | 0.041 | 1.000 | 0.112 | 0.021 | 1.000 | -0.170 | 0.998 | 0.998 | 0.017 | -0.055 |
| rtt_mean | -0.059 | -0.029 | -0.170 | -0.092 | 0.012 | -0.170 | 1.000 | -0.170 | -0.170 | 0.027 | -0.054 |
| rtt_range | -0.057 | 0.042 | 0.998 | 0.108 | 0.010 | 0.998 | -0.170 | 1.000 | 0.999 | 0.017 | -0.055 |
| rtt_std | -0.057 | 0.043 | 0.998 | 0.106 | 0.010 | 0.998 | -0.170 | 0.999 | 1.000 | 0.017 | -0.055 |
| time_since_last | -0.020 | -0.006 | 0.017 | -0.012 | 0.038 | 0.017 | 0.027 | 0.017 | 0.017 | 1.000 | -0.018 |
| tr_id | 0.924 | 0.027 | -0.055 | 0.042 | 0.021 | -0.055 | -0.054 | -0.055 | -0.055 | -0.018 | 1.000 |
Missing values
Sample
| tr_id | route_changed | date_index | rtt_mean | rtt_std | rtt_range | rtt_count | time_since_last | reply_ratio | probe_efficiency | pair_id | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 0 | 1 | 210.09 | 0.0 | 0.0 | 1 | 0.0 | 1.0 | 0.33 | 0 |
| 1 | 1 | 0 | 1 | 210.09 | 0.0 | 0.0 | 1 | 0.0 | 1.0 | 0.33 | 0 |
| 2 | 2 | 0 | 1 | 210.09 | 0.0 | 0.0 | 1 | 0.0 | 1.0 | 0.33 | 0 |
| 3 | 3 | 0 | 1 | 210.09 | 0.0 | 0.0 | 1 | 0.0 | 1.0 | 0.33 | 0 |
| 4 | 4 | 0 | 1 | 210.09 | 0.0 | 0.0 | 1 | 0.0 | 1.0 | 0.33 | 0 |
| 5 | 5 | 0 | 1 | 210.09 | 0.0 | 0.0 | 1 | 0.0 | 1.0 | 0.33 | 0 |
| 6 | 6 | 0 | 1 | 210.09 | 0.0 | 0.0 | 1 | 0.0 | 1.0 | 0.33 | 0 |
| 7 | 7 | 0 | 1 | 210.09 | 0.0 | 0.0 | 1 | 0.0 | 1.0 | 0.33 | 0 |
| 8 | 8 | 0 | 1 | 210.09 | 0.0 | 0.0 | 1 | 0.0 | 1.0 | 0.33 | 0 |
| 9 | 9 | 0 | 1 | 210.09 | 0.0 | 0.0 | 1 | 0.0 | 1.0 | 0.33 | 0 |
| tr_id | route_changed | date_index | rtt_mean | rtt_std | rtt_range | rtt_count | time_since_last | reply_ratio | probe_efficiency | pair_id | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 9999990 | 3469874 | 0 | 25 | 105.94 | 1.51 | 4.19 | 6 | 0.0 | 1.0 | 2.0 | 124 |
| 9999991 | 3469875 | 0 | 25 | 105.94 | 1.51 | 4.19 | 6 | 0.0 | 1.0 | 2.0 | 124 |
| 9999992 | 3469876 | 0 | 25 | 105.94 | 1.51 | 4.19 | 6 | 0.0 | 1.0 | 2.0 | 124 |
| 9999993 | 3469877 | 0 | 25 | 105.94 | 1.51 | 4.19 | 6 | 0.0 | 1.0 | 2.0 | 124 |
| 9999994 | 3469878 | 0 | 25 | 105.94 | 1.51 | 4.19 | 6 | 0.0 | 1.0 | 2.0 | 124 |
| 9999995 | 3469879 | 0 | 25 | 105.94 | 1.51 | 4.19 | 6 | 0.0 | 1.0 | 2.0 | 124 |
| 9999996 | 3469880 | 0 | 25 | 105.94 | 1.51 | 4.19 | 6 | 0.0 | 1.0 | 2.0 | 124 |
| 9999997 | 3469881 | 0 | 25 | 105.94 | 1.51 | 4.19 | 6 | 0.0 | 1.0 | 2.0 | 124 |
| 9999998 | 3469882 | 0 | 25 | 105.94 | 1.51 | 4.19 | 6 | 0.0 | 1.0 | 2.0 | 124 |
| 9999999 | 3469883 | 0 | 25 | 105.94 | 1.51 | 4.19 | 6 | 0.0 | 1.0 | 2.0 | 124 |